<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1" xml:lang="en"><title id="hs138336">pg_stat_last_shoperation</title><body><p>The pg_stat_last_shoperation table contains metadata tracking information
about global objects (roles, tablespaces, etc.).</p><table id="hs138428"><title>pg_catalog.pg_stat_last_shoperation</title><tgroup cols="4"><colspec colnum="1" colname="col1" colwidth="131pt"/><colspec colnum="2" colname="col2" colwidth="102pt"/><colspec colnum="3" colname="col3" colwidth="82pt"/><colspec colnum="4" colname="col4" colwidth="134pt"/><thead><row><entry colname="col1">column</entry><entry colname="col2">type</entry><entry colname="col3">references</entry><entry colname="col4">description</entry></row></thead><tbody><row><entry colname="col1">classid</entry><entry colname="col2">oid</entry><entry colname="col3">pg_class.oid</entry><entry colname="col4">OID of the system catalog containing the object.
</entry></row><row><entry colname="col1"><codeph id="hs163416">objid</codeph></entry><entry colname="col2">oid</entry><entry colname="col3">any OID column</entry><entry colname="col4">OID of the object within its system catalog.</entry></row><row><entry colname="col1"><codeph id="hs163422">staactionname</codeph></entry><entry colname="col2">name</entry><entry colname="col3"/><entry colname="col4">The action that was taken on the object.</entry></row><row><entry colname="col1"><codeph id="hs163427">stasysid</codeph></entry><entry colname="col2">oid</entry><entry colname="col3"/><entry colname="col4"/></row><row><entry colname="col1"><codeph id="hs163432">stausename</codeph></entry><entry colname="col2">name</entry><entry colname="col3"/><entry colname="col4">The name of the role that performed the operation
on this object.</entry></row><row><entry colname="col1"><codeph id="hs163437">stasubtype</codeph></entry><entry colname="col2">text</entry><entry colname="col3"/><entry colname="col4">The type of object operated on or the subclass
of operation performed.</entry></row><row><entry colname="col1"><codeph id="hs163442">statime</codeph></entry><entry colname="col2">timestamp with timezone</entry><entry colname="col3"/><entry colname="col4">The timestamp of the operation. This is the same timestamp that is written to
              the Greenplum Database server log files in case you need to look up more
              detailed information about the operation in the logs.</entry></row></tbody></tgroup></table></body></topic>